﻿DELIMITER //

--
--
DROP PROCEDURE IF EXISTS spZeusPackageReturn
//

-- HU - Rakomány visszaru
-- EN - Package return from customer
--
--
CREATE PROCEDURE spZeusPackageReturn
  (_AccessToken INTEGER, _Type VARCHAR(20), _Code VARCHAR(20), _Quantity DECIMAL(18,6))
BEGIN
  DECLARE _Rows INTEGER;
  DECLARE _UserID INTEGER;
  DECLARE _Lang VARCHAR(10);


  --
  --
  SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = N'Not implemented yet !';



  -- HU - Visszaadja ennek a Rakománynak az adatait
  -- EN - Get the package details
  --
  SELECT Code, ArticleCode, ArticleName, Expired, LocationCode, Quantity, UnitCode, '' Notes
    FROM ZeusPackage
   WHERE Code = _Code;
END
//
